<?php

class InvoiceController extends Controller
{
	/**
	 * @var string the default layout for the views. Defaults to '//layouts/column2', meaning
	 * using two-column layout. See 'protected/views/layouts/column2.php'.
	 */
	public $layout='//layouts/column1';

	/**
	 * @return array action filters
	 */
	public function filters()
	{
		return array(
			'accessControl', // perform access control for CRUD operations
			'postOnly + delete', // we only allow deletion via POST request
		);
	}

	/**
	 * Specifies the access control rules.
	 * This method is used by the 'accessControl' filter.
	 * @return array access control rules
	 */
	public function accessRules()
	{
		return array(
			array('allow',  // allow all users to perform 'index' and 'view' actions
				'actions'=>array('index','view'),
				'users'=>array('*'),
			),
			array('allow', // allow authenticated user to perform 'create' and 'update' actions
				'actions'=>array('create','update'),
				'users'=>array('@'),
			),
			array('allow', // allow admin user to perform 'admin' and 'delete' actions
				'actions'=>array('admin','delete', 'newInvoice', 'wineSelected', 'createNewInvoice', 'saveAndAddItems', 'addPurchase', 'createInvoiceNew', 'ajax', 'ajaxAddressSelected', 'createAndSaveInvoice', 'createInvoiceError'),
				'users'=>array('admin'),
			),
			array('deny',  // deny all users
				'users'=>array('*'),
			),
		);
	}

	/**
	 * Displays a particular model.
	 * @param integer $id the ID of the model to be displayed
	 */
	public function actionView($id)
	{
        $model = Invoice::model()->findByPk($id);

        $criteria = new CDbCriteria;
        $criteria->condition = 'customer_id=:customer_id';
        $criteria->params=array(':customer_id'=>$model->customer_id);

        $address = Address::model()->find($criteria);
        $customer = Customer::model()->find($criteria);

        $this->render('create_invoice', array('model'=>$model, 'customer'=>$customer, 'address'=>$address));
	}

	/**
	 * Creates a new model.
	 * If creation is successful, the browser will be redirected to the 'view' page.
	 */
	public function actionCreate()
	{
		$model=new Invoice;

		// Uncomment the following line if AJAX validation is needed
		// $this->performAjaxValidation($model);

		if(isset($_POST['Invoice']))
		{
			$model->attributes=$_POST['Invoice'];
			if($model->save())
				$this->redirect(array('view','id'=>$model->invoice_id));
		}

		$this->render('create',array(
			'model'=>$model,
		));
	}

	/**
	 * Updates a particular model.
	 * If update is successful, the browser will be redirected to the 'view' page.
	 * @param integer $id the ID of the model to be updated
	 */
	public function actionUpdate($id)
	{
		$model=$this->loadModel($id);

		// Uncomment the following line if AJAX validation is needed
		// $this->performAjaxValidation($model);

		if(isset($_POST['Invoice']))
		{
			$model->attributes=$_POST['Invoice'];
			if($model->save())
				$this->redirect(array('view','id'=>$model->invoice_id));
		}

		$this->render('update',array(
			'model'=>$model,
		));
	}

	/**
	 * Deletes a particular model.
	 * If deletion is successful, the browser will be redirected to the 'admin' page.
	 * @param integer $id the ID of the model to be deleted
	 */
	public function actionDelete($id)
	{
	
		$model = $this->loadModel($id);
	
		// delete purchases
		foreach($model->purchases as $purchase) {
			$purchase_model = Purchase::model()->findByPk($purchase->purchase_id)->delete();
		}
	
		// delete invoice
		$model->delete();

		// if AJAX request (triggered by deletion via admin grid view), we should not redirect the browser
		if(!isset($_GET['ajax']))
			$this->redirect(isset($_POST['returnUrl']) ? $_POST['returnUrl'] : array('admin'));
	}

	/**
	 * Lists all models.
	 */
	public function actionIndex()
	{
		$dataProvider=new CActiveDataProvider('Invoice');
		$this->render('index',array(
			'dataProvider'=>$dataProvider,
		));
	}

	/**
	 * Manages all models.
	 */
	public function actionAdmin()
	{
		$model=new Invoice('search');
		$model->unsetAttributes();  // clear any default values
		if(isset($_GET['Invoice']))
			$model->attributes=$_GET['Invoice'];

		$this->render('admin',array(
			'model'=>$model,
		));
	}

	
	public function actionWineSelected($invoice_id, $customer_id) {
		$model = Invoice::model()->findByPk($invoice_id);
				
		$customer = Customer::model()->findByPk($model->customer_id);
	
		$criteria = new CDbCriteria; 
		$criteria->condition='customer_id=:customer_id';
		$criteria->params=array(':customer_id'=>$customer->customer_id);
		$address = Address::model()->find($criteria); 
		
		$this->render('create_invoice',array('model'=>$model, 'customer'=>$customer, 'address'=>$address));
	}

	public function actionAddPurchase($invoice_id, $customer_id) {

        $model = new Purchase;
        $invoice = Invoice::model()->findByPk($invoice_id);
        $customer = Customer::model()->findByPk($customer_id);
        $criteria = new CDbCriteria;
        $criteria->condition='customer_id=:customer_id';
        $criteria->params=array(':customer_id'=>$customer->customer_id);
        $address = Address::model()->find($criteria);

        if(isset($_POST['wine_id'])) {

			$model->wine_id = $_POST['wine_id'][0];

			$model->customer_id = $customer_id;
			$model->invoice_id = $invoice_id;
			$model->amount = $_POST['Purchase']['amount'];
			$model->tax = 20; //TODO

            if ($_POST["Purchase"]["amount"] == 0) {
                $model->amount = 1;
            }

			if($model->save()) {
				$this->redirect(array('invoice/wineSelected','invoice_id'=>$invoice->invoice_id, 'customer_id'=>$customer->customer_id));
			} else {
				$this->redirect(array('view','id'=>$model->purchase_id));
			}		
		} 

		//$wines = new Wine("new");
		
		// Create filter model and set properties
		$filtersForm = new FiltersForm;
		
		if (isset($_GET['FiltersForm']))
		    $filtersForm->filters=$_GET['FiltersForm'];
		 
		// Get rawData and create dataProvider
		$rawData = Wine::model()->findAll();
		$filteredData=$filtersForm->filter($rawData);
		$dataProvider = new CArrayDataProvider($filteredData, array(
	       'keyField' => 'wine_id', 
	    ));
		
		$this->render('view_wines_for_purchase', array('model'=>$model, 'invoice'=>$invoice, 'customer'=>$customer, 'address'=>$address, 'dataProvider'=>$dataProvider, 'filtersForm'=>$filtersForm));
	}

    public function actionCreateInvoiceNew() {
        unset(Yii::app()->session['customer_id']);
        unset(Yii::app()->session['address_id']);
        $model = new Invoice();
        $this->render('create_invoice_new', array('model'=>$model));
    }
	
	/**
	 * Returns the data model based on the primary key given in the GET variable.
	 * If the data model is not found, an HTTP exception will be raised.
	 * @param integer $id the ID of the model to be loaded
	 * @return Invoice the loaded model
	 * @throws CHttpException
	 */
	public function loadModel($id)
	{
		$model=Invoice::model()->findByPk($id);
		if($model===null)
			throw new CHttpException(404,'The requested page does not exist.');
		return $model;
	}

	/**
	 * Performs the AJAX validation.
	 * @param Invoice $model the model to be validated
	 */
	protected function performAjaxValidation($model)
	{
		if(isset($_POST['ajax']) && $_POST['ajax']==='invoice-form')
		{
			echo CActiveForm::validate($model);
			Yii::app()->end();
		}
	}
	
		
	protected function getSumForInvoice($invoice_id) {
		$criteria = new CDbCriteria;
		$criteria->condition = 'invoice_id=:invoice_id';
		$criteria->params = array(':invoice_id'=>$invoice_id);
		$purchases = Purchase::model()->findAll($criteria);
		
		$sum = 0;
		
		foreach($purchases as $purchase) {
			$sum = $sum + ($purchase->wine->sale_price_net * $purchase->amount);
		}
		
		return $sum;
	}

    protected function getCustomerArray() {
        $customers = Customer::model()->findAll();
        $customer_array = array();

        foreach($customers as $customer) {

            $arr = array($customer->customer_id =>$customer->first_name . " " . $customer->last_name);

            array_push($customer_array, $arr);
        }

        return $customer_array;
    }

    public function actionAjax() {

        if(isset($_POST['customer_id'])) {

            Yii::app()->session['customer_id'] = $_POST['customer_id'];

            $criteria = new CDbCriteria;
            $criteria->condition = 'customer_id=:customer_id';
            $criteria->params=array(':customer_id'=>$_POST['customer_id']);

            $address = Address::model()->findAll($criteria);

            if (count($address) == 1) {
                Yii::app()->session['address_id'] = $address[0]->address_id;
            }

            $arr = array();

            foreach ($address as $a) {

                $arr[$a->address_id] = $a->address . "<br>" . $a->postcode . ", " . $a->place . "<br>" . $a->country;

            }

            $this->renderPartial('_one_address', ['data'=>$arr], false, true);
        }

    }

    public function actionAjaxAddressSelected() {
        Yii::app()->session['address_id'] = $_POST['address'];
    }

    public function actionCreateInvoiceError() {
        $model = new Invoice();

        $this->render('create_invoice_new_error', array('model'=>$model));
    }

    public function actionCreateAndSaveInvoice() {
        $model = new Invoice();

        if (!isset($_SESSION["customer_id"])) {
            $this->redirect(array('createInvoiceError'));
        }

        $model->customer_id = $_SESSION["customer_id"];
        unset(Yii::app()->session['customer_id']);

        if (!isset($_SESSION["address_id"])) {
            $criteria = new CDbCriteria;
            $criteria->condition = 'customer_id=:customer_id';
            $criteria->params=array(':customer_id'=>$model->customer_id);

            $address = Address::model()->find($criteria);
            $model->address_id = $address->address_id;
        } else {
            $model->address_id = $_SESSION["address_id"];
            unset(Yii::app()->session['address_id']);
        }

        $model->date = date('d.m.Y');

        if ($model->save()) {

            $customer = Customer::model()->findByPk($model->customer_id);
            $address = Address::model()->findByPk($model->address_id);

            $this->render('create_invoice', array('model'=>$model, 'customer'=>$customer, 'address'=>$address));
        }
    }
 
}
